package com.team.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface UserMapper {

    /**
     * 查询某用户的密码
     * @param studentId
     * @return
     */
    @Select("select password from user where student_id=#{studentId}")
    String getPswById(String studentId);

    /**
     * 查询某用户的角色
     * @param studentId
     * @return
     */
    @Select("select role from user where student_id=#{studentId}")
    String getRoleById(String studentId);
}
